Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Version Query Pseudocolumns

The version query pseudocolumns are valid only in Oracle Flashback Version Query, which is a form of Oracle Flashback Query. The version query pseudocolumns are:

- `VERSIONS_STARTTIME`: Returns the timestamp of the first version of the rows returned by the query.

- `VERSIONS_STARTSCN`: Returns the SCN of the first version of the rows returned by the query.

- `VERSIONS_ENDTIME`: Returns the timestamp of the last version of the rows returned by the query.

- `VERSIONS_ENDSCN`: Returns the SCN of the last version of the rows returned by the query.

- `VERSIONS_XID`: For each version of each row, returns the transaction ID (a `RAW` number) of the transaction that created that row version.

- `VERSIONS_OPERATION`: For each version of each row, returns a single character representing the operation that caused that row version. The values returned are I (for an insert operation), U (for an update operation) or D (for a delete operation).

  See Also: flashback_query_clause for more information on version queries